Database Upgrade zWar 2.00 RC2 to zWar 2.00 FINAL

You dont need to do the following if you are reinstalling your infusion (reinfuse or upgrade from zwar1.24)

To update your zWar 2.00 RC2 Database to the 2.00 final version you have to do the following steps:


1.) enable user-field: "member-flag"

2.) preview the following code in custom-pages admin (admin-panel -> content-admin -> custom-pages):


<?php
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_memberpics_width smallint(5) UNSIGNED NOT NULL default '30'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_memberpics_height smallint(5) UNSIGNED NOT NULL default '40'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_version varchar(10) NOT NULL default '2.00'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_uploadtypes varchar(150) NOT NULL DEFAULT '.gif,.jpg,.png,.zip,.rar,.tar'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_uploadmax int(12) UNSIGNED NOT NULL DEFAULT '150000'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_uploadlimit tinyint(2) UNSiGNED NOT NULL default '5'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_uploadlimit_type tinyint(1) UNSiGNED NOT NULL default '1'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_show_warsshort tinyint(2) UNSIGNED NOT NULL default '5'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_show_warslong tinyint(2) UNSIGNED NOT NULL default '15'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_show_membercount tinyint(2) UNSIGNED NOT NULL default '8'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_squadinfo_open tinyint(1) UNSIGNED NOT NULL default '1'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_messenger_types varchar(200) NOT NULL default 'ICQ, MSN, XFire'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_settings ADD zwar_voice_types varchar(200) NOT NULL default 'TS, Vent'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_member_list ADD list_teambanner_align tinyint(1) UNSIGNED NOT NULL default '1'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_member_list ADD list_teambanner_showinfo tinyint(1) UNSIGNED NOT NULL default '1'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_member_list ADD list_teambanner_infoalign tinyint(1) UNSIGNED NOT NULL default '3'");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_challenges ADD challenge_country varchar(20) NOT NULL default ''");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_opponents ADD opp_country varchar(20) NOT NULL default ''");

$result = dbquery("ALTER TABLE ".$db_prefix."zwar_squads ADD group_banner_align tinyint(1) UNSIGNED NOT NULL default '1'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_squads ADD group_banner_showinfo tinyint(1) UNSIGNED NOT NULL default '1'");
$result = dbquery("ALTER TABLE ".$db_prefix."zwar_squads ADD group_banner_infoalign tinyint(1) UNSIGNED NOT NULL default '3'");

$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."zwar_match_uploads");
$result = dbquery("CREATE TABLE ".$db_prefix."zwar_match_uploads (
upload_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
upload_war_id int(11) UNSIGNED NOT NULL default '0',
upload_user_id mediumint(8) NOT NULL default '0',
upload_name varchar(50) NOT NULL default '',
upload_file varchar(100) NOT NULL default '',
upload_ext varchar(10) NOT NULL default '',
upload_datestamp int(10) UNSIGNED NOT NULL default '0',
PRIMARY KEY  (upload_id)
) TYPE=MyISAM;");

$result = dbquery("SELECT * FROM ".$db_prefix."zwar_opponents");
if (dbrows($result)) {
	while ($data=dbarray($result)) {
		$result2 = dbquery("UPDATE ".$db_prefix."zwar_opponents SET opp_contact2='ICQ: ".$data['opp_contact2']."' WHERE opp_id='".$data['opp_id']."'");
		$result2 = dbquery("UPDATE ".$db_prefix."zwar_opponents SET opp_contact3='TS: ".$data['opp_contact3']."' WHERE opp_id='".$data['opp_id']."'");
	}
}
?>